The following table specifies the data types supported by old-style system flex fields, dynamic flex fields, and dynamic entity fields.
|
Field Type |
Old-Style Flex Field |
Dynamic Flex Field |
Dynamic Entity Field |
Comment |
|---|---|---|---|---|
|
String |
Yes |
Yes |
Yes |
Free text or a validated string type, up to 4000 characters. |
|
Boolean |
No |
Yes |
Yes |
|
|
Long |
Yes |
Yes |
Yes |
|
|
Double |
Yes |
Yes |
Yes |
Specified as a measured type with units. |
|
Timestamp |
Yes |
Yes |
Yes |
Date and time. Types are enforced at the metafield level. |
|
Built-in enumeration |
No |
Yes |
Yes |
A system-delivered enumeration, such as vessel visit phase. |
|
Many-to-one |
No |
Yes |
Yes |
A foreign key relation to and from system or custom entities. With dynamic flex fields, this affects the delete and purge functionality. If the original entity is not enabled for proxy and if lazy loading does not work, this could also affect performance. |